Create proc [dbo].[SP_SEL_EMPLOYEES_GetByACC_ID]      
@ACC_ID int      
as      
select EMP_ID, ACC_ID,(EMP_FIRSTNAME + ' ' + EMP_LASTNAME) as FULLNAME, EMP_ADDRESS,     
EMP_PHONE, CONVERT (varchar(50), EMP_STARTDATE, 101) as STARTDATE, EMP_LICENSE, EMP_POSITION, 
CONVERT(varchar(20),EMP_COMMISSION) + '%' as EMP_COMMISSION    
from EMPLOYEES      
where  [ACC_ID]=@ACC_ID  order by EMP_STARTDATE desc